set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Agurto, Jorge>
-- Create date: <28/10/2011>
-- Description:	<Trae postnets por filtro>
-- =============================================
CREATE PROCEDURE [GOOGLECODERS].[getPostenetsByBeneficiario]
	@IdBeneficiario int
AS
BEGIN
	SET NOCOUNT ON;

	SELECT p.IdPostnet,
			Marca,
			Modelo
	FROM Postnet p
	INNER JOIN Postnet_X_Beneficiario pb ON
		p.idPostnet = pb.idPostnet
	WHERE (pb.IdBeneficiario = @IdBeneficiario)
END